Plans to build a new royal yacht to drive post-Brexit trade deals have been scrapped with immediate effect.