Pep Guardiola vows Manchester City will regain confidence 'sooner or later' after another defeat