Prova cosi:

codice:
SELECT <elenco_campi>
FROM <tabella>
WHERE <vincoli>
ORDER BY auto DESC
LIMIT 5;