sql pagination performance code example

Example: sql paging query

SELECT * FROM SampleFruits
ORDER BY Id
OFFSET 0 ROWS 
FETCH NEXT 7 ROWS ONLY