It depends on the app. Stickers created in iMessage or Procreate can only be used in messaging apps that support iMessage. Stickers created in third-party apps may be able to be used in more messaging apps.