The British monarch officially launched the multi-sport international competition in Scotland during a vibrant cultural opening ceremony.