Stronger - no.
Longer - you can apply pacth for using another tone for SMS alert. If the tone is long, the vibration will be long too.

This depends on your phone...