已解决。
分页sql示例1，适用于一个排序字段的场景:select * from t_order where id >= (select id from t_order order by id limit 10000000, 1) order by id limit 10;
分页sql示例2，适用于多个排序字段的场景:
select * from t_order a inner Join (select id from t_order order by id1,id2 limit 10000000, 10) b ON a.id1 = b.id1 and a.id2 = b.id2;
已解决。
分页sql示例1，适用于一个排序字段的场景:select * from t_order where id >= (select id from t_order order by id limit 10000000, 1) order by id limit 10;
分页sql示例2，适用于多个排序字段的场景:
select * from t_order a inner Join (select id from t_order order by id1,id2 limit 10000000, 10) b ON a.id1 = b.id1 and a.id2 = b.id2;
参考博客地址：https://blog.csdn.net/androidstarjack/article/details/128213070