Under theme folder, what’s sequence of action for index.php, page.php, single.php?

In general, the most specific template will be used first if it’s available, then WordPress will try the others. It depends on what thing you’re looking at (post, page, taxonomy, etc) and where your’re looking at it (archive, single).

This is all explained in detail by the Template Hierarchy.