On the optimal regularity of the coefficients in hyperbolic Cauchy problems