Comparative Collapse Performance Assessment of Bridge Pier under Near-Fault and Long Duration Ground Motions