Error estimates of a theta-scheme for second-order mean field games