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