The historic bridge connecting England and Scotland over the River Tweed is now open after completion of £10.5m restoration works.