World's longest sea crossing bridge set to open