This is unthinkable, but here I am thinking it: If Trump gave an order to invade Canada, he would be triggering NATO Article V against the United States itself. So the only constitutional response by those officers to such an order is to treat it as an immediate, irrevocable resignation from him.