The following narration has been mentioned in Sahih

Anas bin malik reported that: The Messenger of Allah (s.a.w.) entered the room and we accompanied him… And Ibrahim breathed his last. The eyes of Allah’s Messenger (s.a.w) were filled with tears. Abdur Rehman Ibn Auf said: “You are weeping, O Messenger of Allah (s.a.w).” He (s.a.w.) replied: “Ibn Auf, This is mercy.” Then he said: “Our eyes shed tears and our hearts are filled with grief, but we do not say anything except that by Allah is pleased. O, Ibrahim we are sorrowful due to your separation.”

(Sahih Muslim, 4:1808, Kitabul Fazil. Sunan Abi Dawood 3:193, Kitabul Janaiz, Chapter of weeping for dead. Sunan Ibn Majah 1:507, Sahih Bukhari 1:158)

Anas Ibn Malik says: When Ibrahim the son of the prophet (s.a.w.) died, he (the prophet) said: “Do not shroud him till I have looked at him.” Then he came forward in misery and wept.

Jabir Ibne Abdullah Ansari says that: The Messenger of Allah  (s.a.w.) held the hand of Abdur Rehman bin Auf and took him to Ibrahim, his son, when Ibrahim was in his last moments. The Messenger of Allah (s.a.w.) took him in his lap and began to weep. Abdur Rehman bi Auf said: “You are weeping? The Messenger of Allah (s.a.w.)  And you had yourself prohibited weeping? The Messenger of Allah (s.a.w.) replied: “No, But I had prohibited two kinds of cries of foolish and sinful people: The cry at the time of calamity, and tearing at the face and the collar. And the second is crying like Shaitan.” And there is more in this narration. Abu Isa says that this hadith is good.