Long-standing member of the British eventing team renowned for his cross-country prowess has been retired from competition