当limit 偏移越大时，mysql limit 的性能越差，

select * from t where id>=( select * from t order by id limit 99999,1)limit 100;

或

select * from t where id>=( select * from t  limit 99999,1)limit 100;