[iXam]

MySQL 5.0.x :
set @rank:=0;
select *,@rank:=@rank+1 as rank from scoretable order by score desc;