select * from table limit 800 offset 200; where there is no id to sort. This will fetch last 200 rows.