codice:
select * from (
select * from tabella order by id desc limit 100 ) 
as tab order by id