Disgraced rugby star Stuart Hogg has finally been stripped of his royal honour more than a year after he admitted a prolonged campaign of domestic abuse.