Former UK prime minister had eyed a leading role on Donald Trump’s council after working on the Israel-Hamas peace process