The horse has been described as "extra special" following the retirement confirmation