Prince William was "in pieces" with emotion watching his cousin Zara Tindall win an eventing competition.