If you hesitate so much, you probably shouldn't take it.

This may be a typical example of Peter Principle, that people are forced to take promotion to their level of incompetency.

You are happy as an engineer and presumably do a good job. I don't understand why your boss has to promote you.