select * from (select * from tabella order by id desc limit 10) as t order by id