By the 1990s, he moved in a rarefied world of movie stars and statesmen. But Britain’s greatest modern newspaperman drew his campaigning zeal from his upbringing in Manchester