‘I wish you the best’: US military adviser resigns after Trump’s controversial photo-op at church