Incoming EU Trade Commissioner Phil Hogan has said the “mood music” on a Brexit deal has changed and added he is now “cautiously optimistic” an agreement can be reached.