The music legend, 77, admitted he 'lost it' and was 'consoled for 45 minutes' as he detailed the moving story while on Friday's Graham Norton Show.