SQLServer:
select * from
(
select top @pageSize * from
(
select top (@pageSize*@currentPage) * from page order by _id asc
)t1 order by _id desc
)t2 order by _id asc
select * from
(
select top @pageSize * from
(
select top (@pageSize*@currentPage) * from page order by _id asc
)t1 order by _id desc
)t2 order by _id asc