SELECT UserId, MAX(Punti) as massimo
FROM TABELLA
GROUP BY UserId
ORDER BY massimo