It was narrated that ‘Abdullah bin ‘Amr said: “A man died in Al- Madinah, and he was one of those who were born in Al-Madinah. The Prophet (ﷺ) offered the funeral prayer for him and said: “Would that he had died somewhere other than his birthplace.” A man among the people said: “Why, O Messenger of Allah?” He said: “If a man dies somewhere other than his birthplace, a space will be measured for him in Paradise (as big as the distance) from the place where he was born to the place where he died.”
Source: sunnah.com
Other translations
Arabic
حَدَّثَنَا حَرْمَلَةُ بْنُ يَحْيَى، قَالَ حَدَّثَنَا عَبْدُ اللَّهِ بْنُ وَهْبٍ، حَدَّثَنِي حُيَىُّ بْنُ عَبْدِ اللَّهِ الْمَعَافِرِيُّ، عَنْ أَبِي عَبْدِ الرَّحْمَنِ الْحُبُلِيِّ، عَنْ عَبْدِ اللَّهِ بْنِ عَمْرٍو، قَالَ تُوُفِّيَ رَجُلٌ بِالْمَدِينَةِ مِمَّنْ وُلِدَ بِالْمَدِينَةِ فَصَلَّى عَلَيْهِ النَّبِيُّ ـ صلى الله عليه وسلم ـ فَقَالَ: " يَا لَيْتَهُ مَاتَ فِي غَيْرِ مَوْلِدِهِ " . فَقَالَ رَجُلٌ مِنَ النَّاسِ وَلِمَ يَا رَسُولَ اللَّهِ؟ قَالَ: " إِنَّ الرَّجُلَ إِذَا مَاتَ فِي غَيْرِ مَوْلِدِهِ قِيسَ لَهُ مِنْ مَوْلِدِهِ إِلَى مُنْقَطَعِ أَثَرِهِ فِي الْجَنَّةِ " .
sunnah.com