The US president signed order on Thursday amid growing trade war with Canada after the US enacted tariffs against its northern neighbor