Manchester City manager Pep Guardiola has expressed sympathy for sacked Frank Lampard but said all managers "have to win" to keep their jobs.