Mattis was on vacation when Trump tweeted transgender ban, and he was reportedly ‘appalled’ by it