"He didn't seem okay physically ... [but] mentally, he was the most excited I've seen him in months," the music manager tells Page Six exclusively.