Crimson Advocate swooped late to land the Duke of Cambridge Stakes (G2) for James McDonald and Wathnan Racing.