In The Name of Allaah, The Most Merciful, The Bestower of Mercy.
Allaah [The Most High] stated that Prophet Ibraaheem [peace be upon him] said:
[ وَٱجۡعَل لِّى لِسَانَ صِدۡقٍ۬ فِى ٱلۡأَخِرِينَ – And grant me an honourable mention in later generations]. Imaam As-Sadi [may Allaah have mercy upon him] said, “Meaning, grant me an honourable mention until the end of time”. Alllaah answered his supplication, granted him knowledge and wisdom which made him one of the most virtuous Messengers, joined him with his brothers amongst the Messengers, made him beloved, acknowledged, exalted and praised amongst the followers of all religions throughout time. (1)
Imaam Ibnul Qayyim [may Allaah have mercy upon him] said: The difference between the desire for righteous leadership as opposed to merely desiring leadership: It is the difference between exalting the command of Allaah and being sincere to Allaah as opposed to love of exalting oneself and hastening towards the fulfilment of desires. Indeed the one who is sincere to Allaah and exalts Him, he loves that his Lord is obeyed and not disobeyed; [loves that] Allaah’s Word should be uppermost and that all affairs of the religion should be established sincerely for the sake of Allaah, and [that] the servants should obey Allaah’s commands and keep away from what Allaah has forbidden. He is sincere in his servitude to Allaah and sincere to Allaah’s creation in calling them to the path of Allaah. So he loves to be [an upright] leader in the religion; rather he asks his Lord to make him from the leaders of the righteous people who are followed, just as he is a follower of the righteous. Therefore, if this servant -[i.e. this person] who calls to Allaah- loves that he is considered dignified in the eyes [of the people], revered and beloved in their hearts and is one followed amongst them, so that he is trusted by them and they follow the example of the Messenger through him, then this [desire of his] does not harm him; rather he is praised for it. That is because the caller to Allaah loves that Allaah is obeyed and singled out in worship. He loves to be a means by way of which [people] are aided to [obey Allaah, single out Allaah in worship and follow the Messenger]. And due to this, [when] Allaah mentioned those chosen slaves of His- whom He praised in His revelation and will grant the best of reward on the day they meet Him- He mentioned them with the best of their deeds and characteristics, and then said: [ وَٱلَّذِينَ يَقُولُونَ رَبَّنَا هَبۡ لَنَا مِنۡ أَزۡوَٲجِنَا وَذُرِّيَّـٰتِنَا قُرَّةَ أَعۡيُنٍ۬ وَٱجۡعَلۡنَا لِلۡمُتَّقِينَ إِمَامًا – And those who say: “Our Lord! Bestow on us from our wives and our offspring who will be the comfort of our eyes, and make us leaders for the Muttaqun]. (pious) 25:74
So they ask Allaah to grant them the comfort of the eye by making their wives and offspring obedient to Allaah, and to grant them happiness in their hearts due to being followed by the righteous in obedience and servitude to Allaah. That is because a trustworthy leader in the religion co-operates with [others] upon obedience [to Allaah and His Messenger], and that is to call them to [sound] leadership in the religion, whose foundation is patience and certainty, as Allaah [The Most High] said: [ وَجَعَلۡنَا مِنۡہُمۡ أَٮِٕمَّةً۬ يَہۡدُونَ بِأَمۡرِنَا لَمَّا صَبَرُواْۖ وَڪَانُواْ بِـَٔايَـٰتِنَا يُوقِنُونَ – And We made from among them (Children of Israel), leaders, giving guidance under Our Command, when they were patient and used to believe with certainty in Our Ayat (proofs, evidences, verses, lessons, signs, revelations, etc.). [32:24]
Therefore, in their supplication -[in Surah Al-Furqaan Ayah 74]- to Allaah that He makes them leaders of the righteous people, is that Allaah guides them, grants them success, bless them with beneficial knowledge and righteous actions–outwardly and inwardly–without which [sound] leadership in the religion cannot be achieved.
This is different from [merely] seeking leadership, for indeed its seekers hasten to obtain it in order to achieve their goals, [such as] exaltedness in the earth; enslavement of the hearts to them, attachment to them and aiding them in all their goals, whilst they are exalted and everyone subservient to them. This pursuit of leadership brings about corruption-which none can enumerate except Allaah- such as rebellion, envy, transgression, enmity, oppression, trials, being ardent in defending oneself at the expense of violating the rights of Allaah, exalting those despised by Allaah and belittling those honoured by Allaah. (2)
[Ref 1: An Excerpt From Tafseer As-Sadi. slightly paraphrased]
[Source: An Excerpt from ‘Ar-Rooh’ pages 487-489’. slightly paraphrased]