SQL, return user rank based on specific ORDER BY using MySQL 5.7

I have tables
users: id, name
scores: id, user_id, value, created_at