Will subquery be executed first here with full scan?
PLAN

Your understanding of the Plan seems correct.

Common Misunderstanding

People often forget that SQL is a declarative language, not a procedural language.

You should never assume sub-queries run in a certain order.