The Queen has spoken of her "deep and abiding affection" for Scotland as she officially opened the sixth session of the Scottish Parliament at Holyrood.