The veteran CNN talk show host signed off for the last time, after 25 years in the same seat, in an emotional show including tributes from presidents and broadcasting rivals.