Reorder the state selection caveats doc to emphasise common false positives

### Contributions

- [X] I have read the contribution docs, and understand what's expected of me.

### Link to the page on docs.getdbt.com requiring updates

From [discussion in Slack](https://dbt-labs.slack.com/archives/C04N364M8QY/p1707263080865069?thread_ts=1707262336.922859&cid=C04N364M8QY)

The [false positives](https://docs.getdbt.com/reference/node-selection/state-comparison-caveats#false-positives) section is the most relevant and important way that people get into trouble with state selection, but it's somewhat de-emphasised.

### What part(s) of the page would you like to see updated?

Let's bring it up to the top - the slack thread calls for a ⚠️ and a box around it which is probably overkill, but a bit more emphasis through more worked examples etc

### Additional information

_No response_