Scottish challenger American Affair finished best to land the King Charles III Stakes at Royal Ascot for Jim Goldie and Paul Mulrennan.