Pep Guardiola has had a trophy-laden career as Manchester City manager but doubts have been cast over his future