The singer, 67, became distressed in the middle of a concert and had to be comforted by his wife after receiving the 'worst news ever' earlier that day