Diversity emerging: from competitive exclusion to neutral coexistence in ecosystems