Fiqh-us-Sunnah Volume 5, Hajj and ‘Umrah, Fiqh 5.065A.
Section : Excellence of Makkah Over Madinah.
The majority of scholars believes Makkah has preference over Madinah.
Abdullah bin ‘Adi bin Al-Hamra reported that he heard Allah’s Messenger (peace be upon him) saying, “By Allah ! You (O Makkah) are the best of Allah’ s land, and most beloved to Him. Had I not been driven away from you, I would have never departed (from you).” (Ahmad, Ibn Majah and Tirmizhi) Ibn ‘Abbas said: “Allah’s Messenger (peace be upon him) addressed Makkah saying, ‘How nice a place you are! You are the most beloved place to me! If my people had not driven me away from you I would have never departed (from here) to live somewhere else.”(Tirmizhi considers it a sound hadith)