sorun çözülmüştür teşekürler @ibuluter @ebubekirbastama

SELECT id,number, COUNT(*) AS adet  FROM `data` GROUP BY number ORDER BY COUNT(*)DESC,id