The government has cancelled its plans to build a Brexit trade yacht with "immediate effect", the defence secretary has announced.