Presenter broke down in tears as she said farewell after six years in hosting chair