[Feature] [Linter]: Rule to avoid mixing `await` and `then`

[kpanot]

Context

We want to avoid mixin await and then in the same function.

Original comment: #3710 (comment)

Is it a good idea to mix notation await and then ?
[@matthieu-crouzet]

Proposal

Add / create a linter rule for it

[sdo-1A]

To investigate:
https://eslint.org/docs/latest/rules/require-await
https://typescript-eslint.io/rules/await-thenable/