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

##</code><code>##

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