One of Scotland's best-known political journalists has broken down in tears as he describes facing the prospect of his death.