SELECT t1.id,
(SELECT COUNT(*)
FROM Tablo t2
WHERE t2.name <= t1.name) AS sira,
t.name
FROM Tablo t1
WHERE t.name = 'Ali YILMAZ'


id - sira - ad
12 - 3 - Ali YILMAZ

gibi..