When politician John Profumo had an affair with showgirl Christine Keeler in 1963, it brought down the Conservative government and gave rise to the tabloid press, writes TP O’Mahony