basta modificarla così?:
codice:
SELECT id FROM `immobili` ORDER BY ID DESC LIMIT 10