If you look at the execution plan of this query, it will be like this;
Now lets write the query for SQL Server 2012 paging;
The execution plan for this query is;
Now, it is very clear that the paging query of SQL Server 2012 performed very limited functions and performed 100% index scan. The SQL Server 2008 query performed many additional functions which makes it a bit smaller with my 2 column table.