SELECT * FROM events ORDER BY id ASC LIMIT 10;
SELECT * FROM events ORDER BY id DESC LIMIT 10;
SELECT * FROM (SELECT * FROM events ORDER BY id DESC LIMIT 10) t ORDER BY id;
SELECT * FROM events ORDER BY id ASC LIMIT 2, 10;
Find more questions by tags MySQL