It is narrated from Sayyiduna Umar bin al-Khattab (may Allah be pleased with him) that the Messenger of Allah (peace and blessings be upon him) said: "When Sayyiduna Adam (peace be upon him) committed the slip that he committed, he raised his head towards the Throne and said: 'O Allah, I ask You by the right of Muhammad (peace and blessings be upon him) to forgive me.' So Allah Almighty revealed to him: 'And what is Muhammad (peace and blessings be upon him)? And who is Muhammad (peace and blessings be upon him)?' He said: 'Blessed is Your name! When You created me, I raised my head towards Your Throne, and there it was written: La ilaha illallah, Muhammadun Rasulullah (There is no god but Allah, Muhammad is the Messenger of Allah). So I knew that no one has a higher rank with You than the one whose name You placed with Your name.' Then Allah Almighty revealed to him: 'O Adam, he is the last of the prophets from your offspring, and his nation is the last of the nations from your progeny; and O Adam, were it not for him, I would not have created you.'"
Imam al-Tabarani (may Allah have mercy on him) said: "No one narrated this hadith from Zayd bin Aslam (may Allah have mercy on him) except his son Abd al-Rahman (may Allah have mercy on him), and no one from him except Abdullah bin Isma'il al-Madani (may Allah have mercy on him), and it is narrated from Sayyiduna Umar (may Allah be pleased with him) only with this chain."
Hadith Referenceالمعجم الأوسط / باب الميم / 6502
Hadith Takhrij«أخرجه الحاكم فى «المستدرك» برقم: 4251، والطبراني فى «الصغير» برقم: 992»