Scotland-Northern Ireland bridge: How likely is it to be built?

What are the prospects of the multi-billion pound construction project becoming a reality?

Source