Select records from a Table between Row Numbers

select * from (
select ROW_NUMBER() over (Order by [column_name]) as RowId, *
from [table_name]) as Collections
where Collections.RowId > 10 and Collections.RowId < 20