SELECT id, total
    FROM some_table
   WHERE id > (SELECT MAX(id) FROM some_table) - 10
ORDER BY total DESC