Hailed by Britain’s prime minister in superlatives, the deal opens up significant opportunities. Its success will depend on what comes next