SELECT id, total
FROM table
ORDER BY id, total DESC
LIMIT 10;