Musnad Abi Ya'la 2899 — the Messenger of Allah ﷺ said: Allah Almighty

It is narrated from Sayyiduna Anas bin Malik (may Allah be pleased with him) that the Messenger of Allah (peace and blessings be upon him) said: "Allah Almighty will gather all the people on the Day of Resurrection, and this thought will be put (by inspiration) into their hearts, and they will say: If only we could present someone's intercession before our Lord, so that He would grant us relief from this (distressing) place of ours. So they will come to Adam (peace be upon him) and say: O Adam! You are the father of all mankind; Allah created you with His own Hand and made His angels prostrate to you, so intercede for us with your Lord so that He may deliver us from this place. He will say: I am not fit for this position, and he will recall the slip that he committed, and because of it he will feel shy before his Lord, and he will say: Rather, go to Nuh (peace be upon him), the first messenger whom Allah sent. So they will come to Nuh (peace be upon him), and he too will say: I am not fit for this position, and he will recall the error that he committed and feel shy before his Lord, and he will say: Go to Ibrahim (peace be upon him). He (peace and blessings be upon him) said: Then they will come to Ibrahim (peace be upon him), and he too will say: I am not fit for this, and he will recall his slip and feel shy before his Lord, and he will say: Rather, go to Musa (peace be upon him). Then they will come to Musa (peace be upon him), and he too will say the same: I am not fit for this position, and he will recall his slip and feel ashamed before his Lord, and he will say: Go to Isa (peace be upon him), who is the spirit of Allah and His word. He (peace and blessings be upon him) said: Then they will come to Isa (peace be upon him), and he will say: I am not fit for this position; go to Muhammad (peace and blessings be upon him). He is a servant of Allah whose former and latter sins Allah has all forgiven. He (peace and blessings be upon him) said: So they will come to me, and I will ask my Lord for permission (to intercede), and permission will be granted to me. Then, when I see my Lord, I will fall down in prostration, and Allah Almighty will leave me in that state for as long as He wills. Then it will be said: O Muhammad! Raise your head. Speak, and you will be heard; ask, and you will be given; and intercede, and your intercession will be accepted. So I will raise my head and praise my Lord with such praise as He will teach me. Then I will intercede, and Allah Almighty will set a limit for me, and I will bring those people out of the Fire and admit them into Paradise. Then I will return and fall down in prostration, and praise my Lord with the same praise that He will teach me. Then I will intercede, and Allah Almighty will set another limit for me, and I will bring them out of Hell and admit them into Paradise. Then I will return a third time, fall down in prostration and praise my Lord with the same praise that He will teach me. Then it will be said: O Muhammad! Speak, and your call will be heard; ask, and your wish will be fulfilled; intercede, and your intercession will be accepted. So I will raise my head and praise my Lord with the same praise that He will teach me. Then I will intercede, and Allah Almighty will set for me the limit of a group, and I will bring them out of the Fire and take them into Paradise." And he (peace and blessings be upon him) said on the third or fourth time: "Then none will remain in Hell except those whom the Qur'an has held back." Qatadah (may Allah have mercy on him) said in explanation of this: "This means those upon whom (according to the ruling of the Qur'an) eternal punishment has become due."