The Scottish Parliament is officially opened by Queen Elizabeth on the day powers are officially transferred from the old Scottish Office in London to the new devolved Scottish Executive in Edinburgh.