well its not 'idling' at 4000rpm, because idle is ~750rpm.

you should not be concerned that the engine is running at 4000rpm when doing 120kmh in 6th, thats normal. honda did not just magically throw the wrong gear in your car.