Manchester City legend David Silva has announced his retirement from professional football aged 37 after suffering a significant knee injury.