如何从SQL Server的y行之后选择数据顶部x数据

For example I have a table which contains 10'000 rows. I want to select top 100 rows after top 500th row. How can I do this most efficiently. For example I have a table which contains 10'00