SELECT * FROM
(SELECT *
FROM table
ORDER BY id DESC LIMIT 10) as x
ORDER BY id ASC