[KLS]

SET @idindex = 0;
SELECT skill_id, name, (@idindex:=@idindex+1) FROM altadv_vars ORDER BY skill_id ASC;

Works on 5.0 not sure about other mysql vers.