select
   count(*)+1 as rank
from
   stats
where
   score > (SELECT score FROM stats WHERE id=56);