Prince Andrew: the British royal brought down by scandal