Generally higher octane works fine in most cars but high performance engines not configured to handle either type may knock with lower octane fuel (due to premature ignition with the higher compression ratio), and will generally put out (slightly) less power regardless due to timing adjustments the engine will make to accommodate the change.

Putting premium in a regular car that isn’t designed with higher compression ratios in mind is really just a waste of money.