Deemed a 'huge expense' for both the Duke and Duchess of York, Sunninghill took four years to complete, having been initially gifted to the royal couple by the late Queen as a present for their 1986 wedding