Charles Spencer, 3rd Duke of Marlborough (1706–1758), Soldier