Explain the significance of material selection in mechanical design, considering the trade-offs between mechanical properties, manufacturability, cost, and environmental impact.