Yes it does. Look at top 20-50 schools, the professors there probably got Ph.D.'s from Harvard, MIT, Princeton, etc. Then look at top 50-100 schools: those professors probably got Ph.D.'s from Penn, Ohio State, etc.
Who cares about in-state for funded Ph.D.? Stony Brook isn’t that far.